package com.merck.service.exportTemp;

public class SqlStrTemp {

    public static String FBU_REP_FD_C_FD_S_FD_P = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='FBU' and (role = 'FD_C' or role = 'FD_S' or role = 'FD_P') and position = 'REP'";
    public static String FBU_DSM_FD_BA = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='FBU' and role = 'FD_BA' and position = 'DSM'";
    public static String KPI_FBU_DSM_FD_S_FD_C_FD_P = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='FBU' and (role = 'FD_C' or role = 'FD_S' or role = 'FD_P') and position = 'DSM'";
    public static String FBU_FT_DM_FT = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='FBU' and role = 'FT' and position = 'DSM'";
    public static String KPI_FBU_RSD_NAD = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='FBU'  and position = 'RSM'";

    public static String KPI_GBU_REP_CHD = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='GBU' and role = 'CHD' and position = 'REP'";
    public static String KPI_GBU_REP_ST_TD_DB_CV_MIX = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='GBU' and (role = 'TD' or role = 'ST' or role = 'MIX' or role = 'DB_ID' or role = 'DB_A' or role = 'CV') and position = 'REP'";
    public static String KPI_GBU_DSM_HA = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='GBU' and role = 'HA' and position = 'DSM'";
    public static String KPI_GBU_DSM_ST_TD_DB_CV_MIX_CHD = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='GBU' and (role = 'CHD' or role = 'CV' or role = 'DB_A' or role = 'MIX' or role = 'ST'  or role = 'TD') and position = 'DSM'";
    public static String KPI_GBU_RSM = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='GBU'  and position = 'RSM'";

    public static String KPI_KA_DSM_KA = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='KA' and role = 'KA' and position = 'DSM'";

    public static String KPI_OBU_REP_Erbitux = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='OBU' and upper(role) = 'ERBITUX' and position = 'REP'";
    public static String KPI_OBU_REP_Xalkori = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='OBU' and upper(role) = 'ERBITUX XALKORI' and position = 'REP'";
    public static String KPI_OBU_DSM = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='OBU'  and position = 'DSM'";
    public static String KPI_OBU_RSM = "select  year, quarter,bu,role,position,region_name,position_id,muid,name,parent_name from  lego_kpi_calculation.ads_kpi_manual_template_qf where bu='OBU' and position = 'RSM'";
}
